Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | StockMeter(AS_MTR_STK) |
StockMeterID (FK)(PK) | A unique identifier for the stock meter | ID_MTR_STK | Identity | integer | StockMeter(AS_MTR_STK) |
ReadingNumber (PK) | A sequential number for a stock meter reading. | AI_RDG | LineNumber | smallint | |
MeterValue | The value of the STOCK METER at the time of the reading | QY_RDG | Quantity | decimal(9,2) | |
TimeStamp | The date & time the meter reading was taken | TS_RDG | AuditDateTime | datetime | |
ReasonCode | A 2character code denoting the reason the meter reading was taken | RC_RDG | Code | varchar(20) | |
TransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | ForecourtSettlementTransaction(TR_STLM_FCRT) |